/*
 Navicat Premium Data Transfer

 Source Server         : tx-cloud
 Source Server Type    : MySQL
 Source Server Version : 50639
 Source Host           : 140.143.56.139:3306
 Source Schema         : ipet

 Target Server Type    : MySQL
 Target Server Version : 50639
 File Encoding         : 65001

 Date: 27/03/2019 15:41:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('RenrenScheduler', 'TASK_2', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', NULL, 'io.renren.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000158BAF593307874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B020000787000000000000000017400047465737474000672656E72656E74000FE69C89E58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000007800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('RenrenScheduler', 'TASK_2', 'DEFAULT', NULL, 'io.renren.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000158C377C4607874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000274000574657374327074000FE697A0E58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000017800);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_LOCKS` VALUES ('RenrenScheduler', 'STATE_ACCESS');
INSERT INTO `QRTZ_LOCKS` VALUES ('RenrenScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('RenrenScheduler', 'localhost1520928652534', 1520929139294, 15000);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_TRIGGERS` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', 'TASK_1', 'DEFAULT', NULL, 1520929800000, -1, 5, 'WAITING', 'CRON', 1520052962000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000158BAF593307874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B020000787000000000000000017400047465737474000672656E72656E74000FE69C89E58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000007800);
INSERT INTO `QRTZ_TRIGGERS` VALUES ('RenrenScheduler', 'TASK_2', 'DEFAULT', 'TASK_2', 'DEFAULT', NULL, 1520053200000, -1, 5, 'PAUSED', 'CRON', 1520052962000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000158C377C4607874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000274000574657374327074000FE697A0E58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000017800);
COMMIT;

-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='市级信息';

-- ----------------------------
-- Table structure for country
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `countryname` varchar(255) DEFAULT NULL COMMENT '名称',
  `countrycode` varchar(255) DEFAULT NULL COMMENT '代码',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='国家信息';

-- ----------------------------
-- Table structure for drugs_store
-- ----------------------------
DROP TABLE IF EXISTS `drugs_store`;
CREATE TABLE `drugs_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '药品名称',
  `price` decimal(6,2) DEFAULT NULL COMMENT '价格',
  `inventory` int(10) DEFAULT NULL COMMENT '库存',
  `function` varchar(255) DEFAULT NULL COMMENT '主治功能',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='药房管理';

-- ----------------------------
-- Records of drugs_store
-- ----------------------------
BEGIN;
INSERT INTO `drugs_store` VALUES (1, '阿莫西林胶囊', 20.00, 100, '溶血链球菌、肺炎链球菌、葡萄球菌或流感嗜血杆菌所致中耳炎、鼻窦炎、咽炎、扁桃体炎等上呼吸道感染。');
COMMIT;

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `sex` tinyint(1) NOT NULL,
  `pet_id` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='会员表';

-- ----------------------------
-- Records of member
-- ----------------------------
BEGIN;
INSERT INTO `member` VALUES (1, '白石麻衣', '13011111111', 0, 1000000, '2018-03-23 15:40:32');
INSERT INTO `member` VALUES (2, '藤井树', '13311111111', 1, 1000001, '2018-03-23 15:50:43');
INSERT INTO `member` VALUES (3, '桥本奈奈未', '13011111111', 0, 1000002, '2018-03-23 15:52:31');
COMMIT;

-- ----------------------------
-- Table structure for pet_case
-- ----------------------------
DROP TABLE IF EXISTS `pet_case`;
CREATE TABLE `pet_case` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pet_id` int(11) DEFAULT NULL COMMENT '宠物id',
  `outpatient_no` int(11) DEFAULT NULL COMMENT '门诊号',
  `content` varchar(500) DEFAULT NULL COMMENT '病例内容',
  `drugs` varchar(200) DEFAULT NULL COMMENT '用药',
  `type` int(2) DEFAULT NULL COMMENT '类型：1.药物治疗 2.手术治疗',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='宠物病例表';

-- ----------------------------
-- Records of pet_case
-- ----------------------------
BEGIN;
INSERT INTO `pet_case` VALUES (1, 1, 123, '骨折手术', '麻醉剂', 2, '2018-04-23 18:17:17');
COMMIT;

-- ----------------------------
-- Table structure for pet_category
-- ----------------------------
DROP TABLE IF EXISTS `pet_category`;
CREATE TABLE `pet_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL COMMENT '父id',
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  `del_flag` tinyint(4) DEFAULT NULL COMMENT '删除标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='宠物类别表';

-- ----------------------------
-- Records of pet_category
-- ----------------------------
BEGIN;
INSERT INTO `pet_category` VALUES (1, 0, '犬类', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for pet_charges
-- ----------------------------
DROP TABLE IF EXISTS `pet_charges`;
CREATE TABLE `pet_charges` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `title` varchar(55) DEFAULT NULL COMMENT '收费项',
  `content` varchar(500) DEFAULT NULL COMMENT '收费内容',
  `amount` decimal(6,2) DEFAULT NULL COMMENT '收费金额',
  `pet_id` int(11) DEFAULT NULL COMMENT '宠物id',
  `create_time` datetime DEFAULT NULL COMMENT '收费时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='收费管理';

-- ----------------------------
-- Records of pet_charges
-- ----------------------------
BEGIN;
INSERT INTO `pet_charges` VALUES (1, '骨折手术', '手术费，医药费', 1000.00, 1, '2018-03-11 18:19:18');
INSERT INTO `pet_charges` VALUES (2, '绝育手术', '手术费，医药费', 500.00, 2, '2018-04-28 15:00:23');
INSERT INTO `pet_charges` VALUES (3, '骨折手术', '手术费', 500.00, 3, '2018-04-28 16:16:09');
INSERT INTO `pet_charges` VALUES (4, '皮肤病治疗', '医药费', 200.00, 4, '2018-04-28 16:16:54');
INSERT INTO `pet_charges` VALUES (5, '食物中毒治疗', '医药费', 800.00, 5, '2018-04-28 16:19:05');
INSERT INTO `pet_charges` VALUES (6, '眼病治疗', '医药费', 300.00, 6, '2018-04-28 16:21:46');
INSERT INTO `pet_charges` VALUES (7, '医药费', '阿莫西林胶囊', 20.00, 1, '2018-05-21 14:52:52');
INSERT INTO `pet_charges` VALUES (8, '皮肤病治疗', '手术费，医疗费', 3200.00, 3, '2018-05-21 16:29:12');
INSERT INTO `pet_charges` VALUES (9, '宠物洗澡', '宠物洗澡', 100.00, 1, '2018-06-08 15:59:02');
COMMIT;

-- ----------------------------
-- Table structure for pet_info
-- ----------------------------
DROP TABLE IF EXISTS `pet_info`;
CREATE TABLE `pet_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pet_id` int(11) NOT NULL COMMENT '宠物编号',
  `pet_name` varchar(50) DEFAULT NULL COMMENT '宠物昵称',
  `pet_type` int(11) DEFAULT NULL COMMENT '类型',
  `breed` varchar(200) DEFAULT NULL COMMENT '品种',
  `age` int(2) DEFAULT NULL COMMENT '年龄',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='宠物信息表';

-- ----------------------------
-- Records of pet_info
-- ----------------------------
BEGIN;
INSERT INTO `pet_info` VALUES (1, 1000000, '白白', 1, '柴犬', 1, '2018-03-23 16:30:18');
COMMIT;

-- ----------------------------
-- Table structure for pet_operation
-- ----------------------------
DROP TABLE IF EXISTS `pet_operation`;
CREATE TABLE `pet_operation` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(50) DEFAULT NULL COMMENT '手术名称',
  `content` varchar(500) DEFAULT NULL COMMENT '手术内容',
  `case_id` int(11) DEFAULT NULL COMMENT '病例id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='手术管理';

-- ----------------------------
-- Records of pet_operation
-- ----------------------------
BEGIN;
INSERT INTO `pet_operation` VALUES (1, '骨折手术', '腿部骨折，打石膏', 1, '2018-04-23 18:14:43');
COMMIT;

-- ----------------------------
-- Table structure for pet_sickroom
-- ----------------------------
DROP TABLE IF EXISTS `pet_sickroom`;
CREATE TABLE `pet_sickroom` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `room_no` varchar(25) DEFAULT NULL COMMENT '病房号',
  `bed_no` varchar(25) DEFAULT NULL COMMENT '病床号',
  `pet_id` int(11) DEFAULT NULL COMMENT '宠物id',
  `info` varchar(255) DEFAULT NULL COMMENT '住院信息',
  `operation_id` int(11) DEFAULT NULL COMMENT '手术号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='住院管理';

-- ----------------------------
-- Records of pet_sickroom
-- ----------------------------
BEGIN;
INSERT INTO `pet_sickroom` VALUES (1, 'A-101', '01', 1, '骨折手术住院2天', 1, '2018-04-23 18:18:34');
COMMIT;

-- ----------------------------
-- Table structure for registration
-- ----------------------------
DROP TABLE IF EXISTS `registration`;
CREATE TABLE `registration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `registr_no` int(11) DEFAULT NULL COMMENT '挂号号码',
  `pet_id` int(11) DEFAULT NULL COMMENT '宠物id',
  `amount` decimal(6,2) DEFAULT NULL COMMENT '金额',
  `create_time` datetime DEFAULT NULL COMMENT '挂号时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='挂号管理';

-- ----------------------------
-- Records of registration
-- ----------------------------
BEGIN;
INSERT INTO `registration` VALUES (1, 1, 1, 100.00, '2018-05-21 14:30:16');
INSERT INTO `registration` VALUES (2, 2, 2, 200.00, '2018-05-21 14:30:28');
INSERT INTO `registration` VALUES (3, 3, 2, 300.00, '2018-05-21 14:45:33');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(100) DEFAULT NULL COMMENT '方法名',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint(4) DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='定时任务';

-- ----------------------------
-- Records of schedule_job
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job` VALUES (1, 'testTask', 'test', 'renren', '0 0/30 * * * ?', 0, '有参数测试', '2016-12-01 23:16:46');
INSERT INTO `schedule_job` VALUES (2, 'testTask', 'test2', NULL, '0 0/30 * * * ?', 1, '无参数测试', '2016-12-03 14:55:56');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `job_id` bigint(20) NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(100) DEFAULT NULL COMMENT '方法名',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `status` tinyint(4) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
  `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`),
  KEY `job_id` (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务日志';

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `key` varchar(50) DEFAULT NULL COMMENT 'key',
  `value` varchar(2000) DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统配置信息表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, 'CLOUD_STORAGE_CONFIG_KEY', '{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuBucketName\":\"ios-app\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"type\":1}', 0, '云存储配置信息');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '上级部门ID，一级部门为0',
  `name` varchar(50) DEFAULT NULL COMMENT '部门名称',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  `del_flag` tinyint(4) DEFAULT '0' COMMENT '是否删除  -1：已删除  0：正常',
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='部门管理';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1, 0, 'ipet宠物医院', 0, 0);
INSERT INTO `sys_dept` VALUES (2, 1, '长沙分公司', 1, 0);
INSERT INTO `sys_dept` VALUES (3, 1, '上海分公司', 2, 0);
INSERT INTO `sys_dept` VALUES (4, 3, '技术部', 0, 0);
INSERT INTO `sys_dept` VALUES (5, 3, '销售部', 1, 0);
INSERT INTO `sys_dept` VALUES (6, 1, '北京分公司', 0, 0);
INSERT INTO `sys_dept` VALUES (7, 6, '技术部', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT '字典名称',
  `type` varchar(100) NOT NULL COMMENT '字典类型',
  `code` varchar(100) NOT NULL COMMENT '字典码',
  `value` varchar(1000) NOT NULL COMMENT '字典值',
  `order_num` int(11) DEFAULT '0' COMMENT '排序',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `del_flag` tinyint(4) DEFAULT '0' COMMENT '删除标记  -1：已删除  0：正常',
  PRIMARY KEY (`id`),
  UNIQUE KEY `type` (`type`,`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='数据字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES (1, '性别', 'sex', '0', '女', 0, NULL, 0);
INSERT INTO `sys_dict` VALUES (2, '性别', 'sex', '1', '男', 1, NULL, 0);
INSERT INTO `sys_dict` VALUES (3, '性别', 'sex', '2', '未知', 3, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) DEFAULT NULL COMMENT '请求参数',
  `time` bigint(20) NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (1, 'admin', '保存用户', 'io.renren.modules.sys.controller.SysUserController.save()', '{\"userId\":2,\"username\":\"aj\",\"password\":\"fe805619645face2ccd68eb8140204530e306b3f4bb7a1adc089323f3ef887f4\",\"salt\":\"3re1dJKdSHdizGPT7xTM\",\"email\":\"111111@qq.com\",\"mobile\":\"1111111\",\"status\":1,\"roleIdList\":[],\"createTime\":\"Mar 13, 2018 4:17:25 PM\",\"deptId\":7,\"deptName\":\"技术部\"}', 147, '0:0:0:0:0:0:0:1', '2018-03-13 16:17:25');
INSERT INTO `sys_log` VALUES (2, 'admin', '保存角色', 'io.renren.modules.sys.controller.SysRoleController.save()', '{\"roleId\":1,\"roleName\":\"技术人员\",\"remark\":\"技术\",\"deptId\":7,\"deptName\":\"技术部\",\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,32,33,34,35,36,37,38,39,40],\"deptIdList\":[6,7],\"createTime\":\"Mar 13, 2018 4:18:11 PM\"}', 86, '0:0:0:0:0:0:0:1', '2018-03-13 16:18:12');
INSERT INTO `sys_log` VALUES (3, 'admin', '修改用户', 'io.renren.modules.sys.controller.SysUserController.update()', '{\"userId\":2,\"username\":\"aj\",\"salt\":\"3re1dJKdSHdizGPT7xTM\",\"email\":\"111111@qq.com\",\"mobile\":\"1111111\",\"status\":1,\"roleIdList\":[1],\"createTime\":\"Mar 13, 2018 4:17:25 PM\",\"deptId\":7,\"deptName\":\"技术部\"}', 21, '0:0:0:0:0:0:0:1', '2018-03-13 16:18:29');
INSERT INTO `sys_log` VALUES (4, 'admin', '保存菜单', 'com.ipet.modules.sys.controller.SysMenuController.save()', '{\"menuId\":41,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"会员管理\",\"url\":\"modules/sys/member.html\",\"type\":1,\"orderNum\":9}', 61, '0:0:0:0:0:0:0:1', '2018-03-19 17:59:30');
INSERT INTO `sys_log` VALUES (5, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":41,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"会员管理\",\"url\":\"modules/sys/member.html\",\"type\":1,\"icon\":\"fa fa-user\",\"orderNum\":9}', 22, '0:0:0:0:0:0:0:1', '2018-03-19 18:00:13');
INSERT INTO `sys_log` VALUES (6, 'admin', '保存角色', 'com.ipet.modules.sys.controller.SysRoleController.save()', '{\"roleId\":2,\"roleName\":\"超级管理员\",\"remark\":\"SuperAdmin\",\"deptId\":1,\"deptName\":\"人人开源集团\",\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,32,33,34,35,36,37,38,39,40,41],\"deptIdList\":[1,2,3,4,5,6,7],\"createTime\":\"Mar 19, 2018 6:02:01 PM\"}', 141, '0:0:0:0:0:0:0:1', '2018-03-19 18:02:02');
INSERT INTO `sys_log` VALUES (7, 'admin', '修改用户', 'com.ipet.modules.sys.controller.SysUserController.update()', '{\"userId\":1,\"username\":\"admin\",\"salt\":\"YzcmCZNvbXocrsz9dm8e\",\"email\":\"root@renren.io\",\"mobile\":\"13612345678\",\"status\":1,\"roleIdList\":[2],\"createTime\":\"Nov 11, 2016 11:11:11 AM\",\"deptId\":1,\"deptName\":\"人人开源集团\"}', 37, '0:0:0:0:0:0:0:1', '2018-03-19 18:02:18');
INSERT INTO `sys_log` VALUES (8, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":42,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"会员管理\",\"url\":\"modules/sys/member.html\",\"type\":1,\"icon\":\"fa fa-user\",\"orderNum\":6}', 40, '0:0:0:0:0:0:0:1', '2018-03-20 16:09:57');
INSERT INTO `sys_log` VALUES (9, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":41,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"宠物档案\",\"url\":\"#\",\"type\":1,\"icon\":\"fa fa-book\",\"orderNum\":9}', 7, '0:0:0:0:0:0:0:1', '2018-03-20 16:13:31');
INSERT INTO `sys_log` VALUES (10, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":42,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"会员管理\",\"url\":\"modules/sys/member.html\",\"type\":1,\"icon\":\"fa fa-users\",\"orderNum\":6}', 9, '0:0:0:0:0:0:0:1', '2018-03-20 16:17:32');
INSERT INTO `sys_log` VALUES (11, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":41,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"宠物档案\",\"url\":\"#\",\"type\":1,\"icon\":\"fa fa-paw\",\"orderNum\":9}', 3, '0:0:0:0:0:0:0:1', '2018-03-20 16:17:51');
INSERT INTO `sys_log` VALUES (12, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":41,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"宠物管理\",\"url\":\"#\",\"type\":0,\"icon\":\"fa fa-paw\",\"orderNum\":9}', 31, '0:0:0:0:0:0:0:1', '2018-03-23 15:42:40');
INSERT INTO `sys_log` VALUES (13, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":54,\"parentId\":41,\"parentName\":\"宠物管理\",\"name\":\"宠物信息表\",\"url\":\"modules/sys/petinfo.html\",\"type\":1,\"icon\":\"fa fa-address-card\",\"orderNum\":6}', 21, '0:0:0:0:0:0:0:1', '2018-03-23 16:32:41');
INSERT INTO `sys_log` VALUES (14, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":54,\"parentId\":41,\"parentName\":\"宠物管理\",\"name\":\"宠物信息\",\"url\":\"modules/sys/petinfo.html\",\"type\":1,\"icon\":\"fa fa-address-card\",\"orderNum\":6}', 5, '0:0:0:0:0:0:0:1', '2018-03-23 16:34:27');
INSERT INTO `sys_log` VALUES (15, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":59,\"parentId\":41,\"parentName\":\"宠物管理\",\"name\":\"宠物类别\",\"url\":\"modules/sys/petcategory.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 5, '0:0:0:0:0:0:0:1', '2018-03-23 16:34:42');
INSERT INTO `sys_log` VALUES (16, 'admin', '保存菜单', 'com.ipet.modules.sys.controller.SysMenuController.save()', '{\"menuId\":74,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"诊疗管理\",\"url\":\"#\",\"type\":1,\"orderNum\":0}', 42, '0:0:0:0:0:0:0:1', '2018-04-23 16:47:53');
INSERT INTO `sys_log` VALUES (17, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":74,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"诊疗管理\",\"url\":\"#\",\"type\":0,\"orderNum\":11}', 25, '0:0:0:0:0:0:0:1', '2018-04-23 16:48:27');
INSERT INTO `sys_log` VALUES (18, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":69,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"宠物病例\",\"url\":\"modules/sys/petcase.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 22, '0:0:0:0:0:0:0:1', '2018-04-23 16:49:06');
INSERT INTO `sys_log` VALUES (19, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":64,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"手术管理\",\"url\":\"modules/sys/petoperation.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 6, '0:0:0:0:0:0:0:1', '2018-04-23 16:49:21');
INSERT INTO `sys_log` VALUES (20, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":74,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"诊疗管理\",\"url\":\"#\",\"type\":0,\"icon\":\"fa fa-briefcase-medical\",\"orderNum\":11}', 38, '0:0:0:0:0:0:0:1', '2018-04-23 16:58:23');
INSERT INTO `sys_log` VALUES (21, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":69,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"宠物病例\",\"url\":\"modules/sys/petcase.html\",\"type\":1,\"icon\":\"fa fa-clipboard-list\",\"orderNum\":6}', 8, '0:0:0:0:0:0:0:1', '2018-04-23 16:59:49');
INSERT INTO `sys_log` VALUES (22, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":64,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"手术管理\",\"url\":\"modules/sys/petoperation.html\",\"type\":1,\"icon\":\"fa fa-adn\",\"orderNum\":6}', 9, '0:0:0:0:0:0:0:1', '2018-04-23 17:01:04');
INSERT INTO `sys_log` VALUES (23, 'admin', '保存菜单', 'com.ipet.modules.sys.controller.SysMenuController.save()', '{\"menuId\":75,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"住院管理\",\"type\":0,\"icon\":\"fa fa-hospital\",\"orderNum\":12}', 8, '0:0:0:0:0:0:0:1', '2018-04-23 17:03:06');
INSERT INTO `sys_log` VALUES (24, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":75,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"住院管理\",\"type\":0,\"icon\":\"fa fa-hospital\",\"orderNum\":12}', 5, '0:0:0:0:0:0:0:1', '2018-04-23 17:03:54');
INSERT INTO `sys_log` VALUES (25, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":74,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"诊疗管理\",\"url\":\"#\",\"type\":0,\"icon\":\"fas fa-briefcase-medical\",\"orderNum\":11}', 8, '0:0:0:0:0:0:0:1', '2018-04-23 17:05:37');
INSERT INTO `sys_log` VALUES (26, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":69,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"宠物病例\",\"url\":\"modules/sys/petcase.html\",\"type\":1,\"icon\":\"fas fa-clipboard-list\",\"orderNum\":6}', 5, '0:0:0:0:0:0:0:1', '2018-04-23 17:05:52');
INSERT INTO `sys_log` VALUES (27, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":75,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"住院管理\",\"type\":0,\"icon\":\"fa fa-room\",\"orderNum\":12}', 6, '0:0:0:0:0:0:0:1', '2018-04-23 17:06:49');
INSERT INTO `sys_log` VALUES (28, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":74,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"诊疗管理\",\"url\":\"#\",\"type\":0,\"icon\":\"fa fa-plus-square\",\"orderNum\":11}', 9, '0:0:0:0:0:0:0:1', '2018-04-23 17:07:54');
INSERT INTO `sys_log` VALUES (29, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":69,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"宠物病例\",\"url\":\"modules/sys/petcase.html\",\"type\":1,\"icon\":\"fa fa-clipboard\",\"orderNum\":6}', 9, '0:0:0:0:0:0:0:1', '2018-04-23 17:09:35');
INSERT INTO `sys_log` VALUES (30, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":64,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"手术管理\",\"url\":\"modules/sys/petoperation.html\",\"type\":1,\"icon\":\"fa fa-first-aid\",\"orderNum\":6}', 9, '0:0:0:0:0:0:0:1', '2018-04-23 17:10:49');
INSERT INTO `sys_log` VALUES (31, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":64,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"手术管理\",\"url\":\"modules/sys/petoperation.html\",\"type\":1,\"icon\":\"fa fa-hospital-alt\",\"orderNum\":6}', 6, '0:0:0:0:0:0:0:1', '2018-04-23 17:11:54');
INSERT INTO `sys_log` VALUES (32, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":64,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"手术管理\",\"url\":\"modules/sys/petoperation.html\",\"type\":1,\"icon\":\"fa fa-medkit\",\"orderNum\":6}', 6, '0:0:0:0:0:0:0:1', '2018-04-23 17:12:47');
INSERT INTO `sys_log` VALUES (33, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":74,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"诊疗管理\",\"url\":\"#\",\"type\":0,\"icon\":\"fa fa-medkit\",\"orderNum\":11}', 5, '0:0:0:0:0:0:0:1', '2018-04-23 17:13:20');
INSERT INTO `sys_log` VALUES (34, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":64,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"手术管理\",\"url\":\"modules/sys/petoperation.html\",\"type\":1,\"icon\":\"fa fa-notes-medical\",\"orderNum\":6}', 7, '0:0:0:0:0:0:0:1', '2018-04-23 17:13:59');
INSERT INTO `sys_log` VALUES (35, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":64,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"手术管理\",\"url\":\"modules/sys/petoperation.html\",\"type\":1,\"icon\":\"fa fa-syringe\",\"orderNum\":6}', 8, '0:0:0:0:0:0:0:1', '2018-04-23 17:15:25');
INSERT INTO `sys_log` VALUES (36, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":75,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"住院管理\",\"type\":0,\"icon\":\"fa fa-buliding\",\"orderNum\":12}', 8, '0:0:0:0:0:0:0:1', '2018-04-23 17:15:43');
INSERT INTO `sys_log` VALUES (37, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":64,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"手术管理\",\"url\":\"modules/sys/petoperation.html\",\"type\":1,\"icon\":\"fa fa-thermometer\",\"orderNum\":6}', 6, '0:0:0:0:0:0:0:1', '2018-04-23 17:16:12');
INSERT INTO `sys_log` VALUES (38, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":64,\"parentId\":74,\"parentName\":\"诊疗管理\",\"name\":\"手术管理\",\"url\":\"modules/sys/petoperation.html\",\"type\":1,\"icon\":\"fa fa-user-md\",\"orderNum\":6}', 10, '0:0:0:0:0:0:0:1', '2018-04-23 17:17:07');
INSERT INTO `sys_log` VALUES (39, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":75,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"住院管理\",\"type\":0,\"icon\":\"fa fa-bed\",\"orderNum\":12}', 5, '0:0:0:0:0:0:0:1', '2018-04-23 17:17:42');
INSERT INTO `sys_log` VALUES (40, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":76,\"parentId\":75,\"parentName\":\"住院管理\",\"name\":\"住院管理\",\"url\":\"modules/sys/petsickroom.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 37, '0:0:0:0:0:0:0:1', '2018-04-23 18:01:41');
INSERT INTO `sys_log` VALUES (41, 'admin', '保存菜单', 'com.ipet.modules.sys.controller.SysMenuController.save()', '{\"menuId\":86,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"财务管理\",\"type\":0,\"orderNum\":11}', 8, '0:0:0:0:0:0:0:1', '2018-04-23 18:02:08');
INSERT INTO `sys_log` VALUES (42, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":81,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"收费管理\",\"url\":\"modules/sys/petcharges.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 9, '0:0:0:0:0:0:0:1', '2018-04-23 18:02:25');
INSERT INTO `sys_log` VALUES (43, 'admin', '删除菜单', 'com.ipet.modules.sys.controller.SysMenuController.delete()', '6', 0, '0:0:0:0:0:0:0:1', '2018-04-23 18:02:36');
INSERT INTO `sys_log` VALUES (44, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":86,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"财务管理\",\"type\":0,\"icon\":\"fa fa-money\",\"orderNum\":11}', 10, '0:0:0:0:0:0:0:1', '2018-04-23 18:06:24');
INSERT INTO `sys_log` VALUES (45, 'admin', '保存菜单', 'com.ipet.modules.sys.controller.SysMenuController.save()', '{\"menuId\":87,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计\",\"url\":\"modules/sys/statistics.html\",\"type\":1,\"orderNum\":7}', 59, '0:0:0:0:0:0:0:1', '2018-04-28 15:13:28');
INSERT INTO `sys_log` VALUES (46, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":87,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计\",\"url\":\"modules/sys/statistics.html\",\"type\":1,\"icon\":\"fa-fa-chart-bar\",\"orderNum\":7}', 32, '0:0:0:0:0:0:0:1', '2018-04-28 15:22:14');
INSERT INTO `sys_log` VALUES (47, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":87,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计\",\"url\":\"modules/sys/statistics.html\",\"type\":1,\"icon\":\"fa-fa-chart\",\"orderNum\":7}', 7, '0:0:0:0:0:0:0:1', '2018-04-28 15:22:43');
INSERT INTO `sys_log` VALUES (48, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":87,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计\",\"url\":\"modules/sys/statistics.html\",\"type\":1,\"icon\":\"fa-fa-chart-line\",\"orderNum\":7}', 7, '0:0:0:0:0:0:0:1', '2018-04-28 15:22:53');
INSERT INTO `sys_log` VALUES (49, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":87,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计\",\"url\":\"modules/sys/statistics.html\",\"type\":1,\"icon\":\"fa-fa-stats\",\"orderNum\":7}', 9, '0:0:0:0:0:0:0:1', '2018-04-28 15:24:30');
INSERT INTO `sys_log` VALUES (50, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":87,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计\",\"url\":\"modules/sys/statistics.html\",\"type\":1,\"icon\":\"fa fa-stats\",\"orderNum\":7}', 7, '0:0:0:0:0:0:0:1', '2018-04-28 15:25:10');
INSERT INTO `sys_log` VALUES (51, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":87,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计\",\"url\":\"modules/sys/statistics.html\",\"type\":1,\"icon\":\"fa fa-chart-line\",\"orderNum\":7}', 6, '0:0:0:0:0:0:0:1', '2018-04-28 15:25:25');
INSERT INTO `sys_log` VALUES (52, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":87,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计\",\"url\":\"modules/sys/statistics.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":7}', 8, '0:0:0:0:0:0:0:1', '2018-04-28 15:25:39');
INSERT INTO `sys_log` VALUES (53, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":88,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"药房管理\",\"url\":\"modules/sys/drugsstore.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 48, '0:0:0:0:0:0:0:1', '2018-05-21 14:17:41');
INSERT INTO `sys_log` VALUES (54, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":93,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"挂号管理\",\"url\":\"modules/sys/registration.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 5, '0:0:0:0:0:0:0:1', '2018-05-21 14:18:04');
INSERT INTO `sys_log` VALUES (55, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":88,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"药房管理\",\"url\":\"modules/sys/drugsstore.html\",\"type\":1,\"icon\":\"fa fa-file-code-drugs\",\"orderNum\":6}', 8, '0:0:0:0:0:0:0:1', '2018-05-21 14:21:28');
INSERT INTO `sys_log` VALUES (56, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":88,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"药房管理\",\"url\":\"modules/sys/drugsstore.html\",\"type\":1,\"icon\":\"fa fa-file-code-drug\",\"orderNum\":6}', 4, '0:0:0:0:0:0:0:1', '2018-05-21 14:21:36');
INSERT INTO `sys_log` VALUES (57, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":88,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"药房管理\",\"url\":\"modules/sys/drugsstore.html\",\"type\":1,\"icon\":\"fa fa-file-code-house\",\"orderNum\":6}', 5, '0:0:0:0:0:0:0:1', '2018-05-21 14:21:47');
INSERT INTO `sys_log` VALUES (58, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":88,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"药房管理\",\"url\":\"modules/sys/drugsstore.html\",\"type\":1,\"icon\":\"fa fa-drugs\",\"orderNum\":6}', 4, '0:0:0:0:0:0:0:1', '2018-05-21 14:23:08');
INSERT INTO `sys_log` VALUES (59, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":88,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"药房管理\",\"url\":\"modules/sys/drugsstore.html\",\"type\":1,\"icon\":\"fa fa-archive\",\"orderNum\":6}', 7, '0:0:0:0:0:0:0:1', '2018-05-21 14:23:15');
INSERT INTO `sys_log` VALUES (60, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":93,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"挂号管理\",\"url\":\"modules/sys/registration.html\",\"type\":1,\"icon\":\"fa fa-code\",\"orderNum\":6}', 6, '0:0:0:0:0:0:0:1', '2018-05-21 14:23:30');
INSERT INTO `sys_log` VALUES (61, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":93,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"挂号管理\",\"url\":\"modules/sys/registration.html\",\"type\":1,\"icon\":\"fa fa-number\",\"orderNum\":6}', 5, '0:0:0:0:0:0:0:1', '2018-05-21 14:23:58');
INSERT INTO `sys_log` VALUES (62, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":93,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"挂号管理\",\"url\":\"modules/sys/registration.html\",\"type\":1,\"icon\":\"fa fa-list\",\"orderNum\":6}', 10, '0:0:0:0:0:0:0:1', '2018-05-21 14:25:44');
INSERT INTO `sys_log` VALUES (63, 'admin', '保存菜单', 'com.ipet.modules.sys.controller.SysMenuController.save()', '{\"menuId\":98,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"会员管理\",\"type\":0,\"orderNum\":2}', 25, '0:0:0:0:0:0:0:1', '2018-05-21 14:49:17');
INSERT INTO `sys_log` VALUES (64, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":42,\"parentId\":98,\"parentName\":\"会员管理\",\"name\":\"会员管理\",\"url\":\"modules/sys/member.html\",\"type\":1,\"icon\":\"fa fa-users\",\"orderNum\":6}', 14, '0:0:0:0:0:0:0:1', '2018-05-21 14:49:44');
INSERT INTO `sys_log` VALUES (65, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":98,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"会员管理\",\"type\":0,\"icon\":\"fa fa-users\",\"orderNum\":2}', 6, '0:0:0:0:0:0:0:1', '2018-05-21 14:50:01');
INSERT INTO `sys_log` VALUES (66, 'admin', '保存菜单', 'com.ipet.modules.sys.controller.SysMenuController.save()', '{\"menuId\":99,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"药房管理\",\"type\":0,\"orderNum\":3}', 5, '0:0:0:0:0:0:0:1', '2018-05-21 14:50:48');
INSERT INTO `sys_log` VALUES (67, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":88,\"parentId\":99,\"parentName\":\"药房管理\",\"name\":\"药品管理\",\"url\":\"modules/sys/drugsstore.html\",\"type\":1,\"icon\":\"fa fa-archive\",\"orderNum\":6}', 7, '0:0:0:0:0:0:0:1', '2018-05-21 14:51:20');
INSERT INTO `sys_log` VALUES (68, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":99,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"药房管理\",\"type\":0,\"icon\":\"fa fa-ambulance\",\"orderNum\":3}', 6, '0:0:0:0:0:0:0:1', '2018-05-21 14:51:59');
INSERT INTO `sys_log` VALUES (69, 'admin', '保存菜单', 'com.ipet.modules.sys.controller.SysMenuController.save()', '{\"menuId\":100,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计(月份)\",\"url\":\"modules/sys/statisticsMonths.html\",\"type\":1,\"orderNum\":9}', 39, '0:0:0:0:0:0:0:1', '2018-05-21 16:27:03');
INSERT INTO `sys_log` VALUES (70, 'admin', '修改菜单', 'com.ipet.modules.sys.controller.SysMenuController.update()', '{\"menuId\":100,\"parentId\":86,\"parentName\":\"财务管理\",\"name\":\"财务统计(月份)\",\"url\":\"modules/sys/statisticsMonths.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":9}', 15, '0:0:0:0:0:0:0:1', '2018-05-21 16:27:25');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', NULL, NULL, 0, 'fa fa-cog', 0);
INSERT INTO `sys_menu` VALUES (2, 1, '管理员管理', 'modules/sys/user.html', NULL, 1, 'fa fa-user', 1);
INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', 'modules/sys/role.html', NULL, 1, 'fa fa-user-secret', 2);
INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', 'modules/sys/menu.html', NULL, 1, 'fa fa-th-list', 3);
INSERT INTO `sys_menu` VALUES (5, 1, 'SQL监控', 'druid/sql.html', NULL, 1, 'fa fa-bug', 4);
INSERT INTO `sys_menu` VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:perms', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:perms', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (27, 1, '参数管理', 'modules/sys/config.html', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'fa fa-sun-o', 6);
INSERT INTO `sys_menu` VALUES (29, 1, '系统日志', 'modules/sys/log.html', 'sys:log:list', 1, 'fa fa-file-text-o', 7);
INSERT INTO `sys_menu` VALUES (30, 1, '文件上传', 'modules/oss/oss.html', 'sys:oss:all', 1, 'fa fa-file-image-o', 6);
INSERT INTO `sys_menu` VALUES (31, 1, '部门管理', 'modules/sys/dept.html', NULL, 1, 'fa fa-file-code-o', 1);
INSERT INTO `sys_menu` VALUES (32, 31, '查看', NULL, 'sys:dept:list,sys:dept:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (33, 31, '新增', NULL, 'sys:dept:save,sys:dept:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (34, 31, '修改', NULL, 'sys:dept:update,sys:dept:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (35, 31, '删除', NULL, 'sys:dept:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (36, 1, '字典管理', 'modules/sys/dict.html', NULL, 1, 'fa fa-bookmark-o', 6);
INSERT INTO `sys_menu` VALUES (37, 36, '查看', NULL, 'sys:dict:list,sys:dict:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (38, 36, '新增', NULL, 'sys:dict:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (39, 36, '修改', NULL, 'sys:dict:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (40, 36, '删除', NULL, 'sys:dict:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (41, 0, '宠物管理', '', NULL, 0, 'fa fa-paw', 9);
INSERT INTO `sys_menu` VALUES (42, 98, '会员管理', 'modules/sys/member.html', NULL, 1, 'fa fa-users', 6);
INSERT INTO `sys_menu` VALUES (43, 42, '查看', NULL, 'sys:member:list,sys:member:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (44, 42, '新增', NULL, 'sys:member:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (45, 42, '修改', NULL, 'sys:member:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (46, 42, '删除', NULL, 'sys:member:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (54, 41, '宠物信息', 'modules/sys/petinfo.html', NULL, 1, 'fa fa-address-card', 6);
INSERT INTO `sys_menu` VALUES (55, 54, '查看', NULL, 'sys:petinfo:list,sys:petinfo:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (56, 54, '新增', NULL, 'sys:petinfo:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (57, 54, '修改', NULL, 'sys:petinfo:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (58, 54, '删除', NULL, 'sys:petinfo:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (59, 41, '宠物类别', 'modules/sys/petcategory.html', NULL, 1, 'fa fa-file-code-o', 6);
INSERT INTO `sys_menu` VALUES (60, 59, '查看', NULL, 'sys:petcategory:list,sys:petcategory:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (61, 59, '新增', NULL, 'sys:petcategory:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (62, 59, '修改', NULL, 'sys:petcategory:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (63, 59, '删除', NULL, 'sys:petcategory:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (64, 74, '手术管理', 'modules/sys/petoperation.html', NULL, 1, 'fa fa-user-md', 6);
INSERT INTO `sys_menu` VALUES (65, 64, '查看', NULL, 'sys:petoperation:list,sys:petoperation:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (66, 64, '新增', NULL, 'sys:petoperation:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (67, 64, '修改', NULL, 'sys:petoperation:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (68, 64, '删除', NULL, 'sys:petoperation:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (69, 74, '宠物病例', 'modules/sys/petcase.html', NULL, 1, 'fa fa-clipboard', 6);
INSERT INTO `sys_menu` VALUES (70, 69, '查看', NULL, 'sys:petcase:list,sys:petcase:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (71, 69, '新增', NULL, 'sys:petcase:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (72, 69, '修改', NULL, 'sys:petcase:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (73, 69, '删除', NULL, 'sys:petcase:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (74, 0, '诊疗管理', '#', NULL, 0, 'fa fa-medkit', 11);
INSERT INTO `sys_menu` VALUES (75, 0, '住院管理', NULL, NULL, 0, 'fa fa-bed', 12);
INSERT INTO `sys_menu` VALUES (76, 75, '住院管理', 'modules/sys/petsickroom.html', NULL, 1, 'fa fa-file-code-o', 6);
INSERT INTO `sys_menu` VALUES (77, 76, '查看', NULL, 'sys:petsickroom:list,sys:petsickroom:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (78, 76, '新增', NULL, 'sys:petsickroom:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (79, 76, '修改', NULL, 'sys:petsickroom:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (80, 76, '删除', NULL, 'sys:petsickroom:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (81, 86, '收费管理', 'modules/sys/petcharges.html', NULL, 1, 'fa fa-file-code-o', 6);
INSERT INTO `sys_menu` VALUES (82, 81, '查看', NULL, 'sys:petcharges:list,sys:petcharges:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (83, 81, '新增', NULL, 'sys:petcharges:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (84, 81, '修改', NULL, 'sys:petcharges:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (85, 81, '删除', NULL, 'sys:petcharges:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (86, 0, '财务管理', NULL, NULL, 0, 'fa fa-money', 11);
INSERT INTO `sys_menu` VALUES (87, 86, '财务统计', 'modules/sys/statistics.html', NULL, 1, 'fa fa-file-code-o', 7);
INSERT INTO `sys_menu` VALUES (88, 99, '药品管理', 'modules/sys/drugsstore.html', NULL, 1, 'fa fa-archive', 6);
INSERT INTO `sys_menu` VALUES (89, 88, '查看', NULL, 'sys:drugsstore:list,sys:drugsstore:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (90, 88, '新增', NULL, 'sys:drugsstore:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (91, 88, '修改', NULL, 'sys:drugsstore:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (92, 88, '删除', NULL, 'sys:drugsstore:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (93, 0, '挂号管理', 'modules/sys/registration.html', NULL, 1, 'fa fa-list', 6);
INSERT INTO `sys_menu` VALUES (94, 93, '查看', NULL, 'sys:registration:list,sys:registration:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (95, 93, '新增', NULL, 'sys:registration:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (96, 93, '修改', NULL, 'sys:registration:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (97, 93, '删除', NULL, 'sys:registration:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (98, 0, '会员管理', NULL, NULL, 0, 'fa fa-users', 2);
INSERT INTO `sys_menu` VALUES (99, 0, '药房管理', NULL, NULL, 0, 'fa fa-ambulance', 3);
INSERT INTO `sys_menu` VALUES (100, 86, '财务统计(月份)', 'modules/sys/statisticsMonths.html', NULL, 1, 'fa fa-file-code-o', 9);
COMMIT;

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件上传';

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '技术人员', '技术', 7, '2018-03-13 16:18:12');
INSERT INTO `sys_role` VALUES (2, '超级管理员', 'SuperAdmin', 1, '2018-03-19 18:02:02');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='角色与部门对应关系';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_dept` VALUES (1, 1, 6);
INSERT INTO `sys_role_dept` VALUES (2, 1, 7);
INSERT INTO `sys_role_dept` VALUES (3, 2, 1);
INSERT INTO `sys_role_dept` VALUES (4, 2, 2);
INSERT INTO `sys_role_dept` VALUES (5, 2, 3);
INSERT INTO `sys_role_dept` VALUES (6, 2, 4);
INSERT INTO `sys_role_dept` VALUES (7, 2, 5);
INSERT INTO `sys_role_dept` VALUES (8, 2, 6);
INSERT INTO `sys_role_dept` VALUES (9, 2, 7);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8 COMMENT='角色与菜单对应关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (1, 1, 1);
INSERT INTO `sys_role_menu` VALUES (2, 1, 2);
INSERT INTO `sys_role_menu` VALUES (3, 1, 15);
INSERT INTO `sys_role_menu` VALUES (4, 1, 16);
INSERT INTO `sys_role_menu` VALUES (5, 1, 17);
INSERT INTO `sys_role_menu` VALUES (6, 1, 18);
INSERT INTO `sys_role_menu` VALUES (7, 1, 3);
INSERT INTO `sys_role_menu` VALUES (8, 1, 19);
INSERT INTO `sys_role_menu` VALUES (9, 1, 20);
INSERT INTO `sys_role_menu` VALUES (10, 1, 21);
INSERT INTO `sys_role_menu` VALUES (11, 1, 22);
INSERT INTO `sys_role_menu` VALUES (12, 1, 4);
INSERT INTO `sys_role_menu` VALUES (13, 1, 23);
INSERT INTO `sys_role_menu` VALUES (14, 1, 24);
INSERT INTO `sys_role_menu` VALUES (15, 1, 25);
INSERT INTO `sys_role_menu` VALUES (16, 1, 26);
INSERT INTO `sys_role_menu` VALUES (17, 1, 5);
INSERT INTO `sys_role_menu` VALUES (18, 1, 6);
INSERT INTO `sys_role_menu` VALUES (19, 1, 7);
INSERT INTO `sys_role_menu` VALUES (20, 1, 8);
INSERT INTO `sys_role_menu` VALUES (21, 1, 9);
INSERT INTO `sys_role_menu` VALUES (22, 1, 10);
INSERT INTO `sys_role_menu` VALUES (23, 1, 11);
INSERT INTO `sys_role_menu` VALUES (24, 1, 12);
INSERT INTO `sys_role_menu` VALUES (25, 1, 13);
INSERT INTO `sys_role_menu` VALUES (26, 1, 14);
INSERT INTO `sys_role_menu` VALUES (27, 1, 27);
INSERT INTO `sys_role_menu` VALUES (28, 1, 29);
INSERT INTO `sys_role_menu` VALUES (29, 1, 30);
INSERT INTO `sys_role_menu` VALUES (30, 1, 31);
INSERT INTO `sys_role_menu` VALUES (31, 1, 32);
INSERT INTO `sys_role_menu` VALUES (32, 1, 33);
INSERT INTO `sys_role_menu` VALUES (33, 1, 34);
INSERT INTO `sys_role_menu` VALUES (34, 1, 35);
INSERT INTO `sys_role_menu` VALUES (35, 1, 36);
INSERT INTO `sys_role_menu` VALUES (36, 1, 37);
INSERT INTO `sys_role_menu` VALUES (37, 1, 38);
INSERT INTO `sys_role_menu` VALUES (38, 1, 39);
INSERT INTO `sys_role_menu` VALUES (39, 1, 40);
INSERT INTO `sys_role_menu` VALUES (40, 2, 1);
INSERT INTO `sys_role_menu` VALUES (41, 2, 2);
INSERT INTO `sys_role_menu` VALUES (42, 2, 15);
INSERT INTO `sys_role_menu` VALUES (43, 2, 16);
INSERT INTO `sys_role_menu` VALUES (44, 2, 17);
INSERT INTO `sys_role_menu` VALUES (45, 2, 18);
INSERT INTO `sys_role_menu` VALUES (46, 2, 3);
INSERT INTO `sys_role_menu` VALUES (47, 2, 19);
INSERT INTO `sys_role_menu` VALUES (48, 2, 20);
INSERT INTO `sys_role_menu` VALUES (49, 2, 21);
INSERT INTO `sys_role_menu` VALUES (50, 2, 22);
INSERT INTO `sys_role_menu` VALUES (51, 2, 4);
INSERT INTO `sys_role_menu` VALUES (52, 2, 23);
INSERT INTO `sys_role_menu` VALUES (53, 2, 24);
INSERT INTO `sys_role_menu` VALUES (54, 2, 25);
INSERT INTO `sys_role_menu` VALUES (55, 2, 26);
INSERT INTO `sys_role_menu` VALUES (56, 2, 5);
INSERT INTO `sys_role_menu` VALUES (57, 2, 6);
INSERT INTO `sys_role_menu` VALUES (58, 2, 7);
INSERT INTO `sys_role_menu` VALUES (59, 2, 8);
INSERT INTO `sys_role_menu` VALUES (60, 2, 9);
INSERT INTO `sys_role_menu` VALUES (61, 2, 10);
INSERT INTO `sys_role_menu` VALUES (62, 2, 11);
INSERT INTO `sys_role_menu` VALUES (63, 2, 12);
INSERT INTO `sys_role_menu` VALUES (64, 2, 13);
INSERT INTO `sys_role_menu` VALUES (65, 2, 14);
INSERT INTO `sys_role_menu` VALUES (66, 2, 27);
INSERT INTO `sys_role_menu` VALUES (67, 2, 29);
INSERT INTO `sys_role_menu` VALUES (68, 2, 30);
INSERT INTO `sys_role_menu` VALUES (69, 2, 31);
INSERT INTO `sys_role_menu` VALUES (70, 2, 32);
INSERT INTO `sys_role_menu` VALUES (71, 2, 33);
INSERT INTO `sys_role_menu` VALUES (72, 2, 34);
INSERT INTO `sys_role_menu` VALUES (73, 2, 35);
INSERT INTO `sys_role_menu` VALUES (74, 2, 36);
INSERT INTO `sys_role_menu` VALUES (75, 2, 37);
INSERT INTO `sys_role_menu` VALUES (76, 2, 38);
INSERT INTO `sys_role_menu` VALUES (77, 2, 39);
INSERT INTO `sys_role_menu` VALUES (78, 2, 40);
INSERT INTO `sys_role_menu` VALUES (79, 2, 41);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) DEFAULT NULL COMMENT '盐',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', 'e1153123d7d180ceeb820d577ff119876678732a68eef4e6ffc0b1f06a01f91b', 'YzcmCZNvbXocrsz9dm8e', 'root@renren.io', '13612345678', 1, 1, '2016-11-11 11:11:11');
INSERT INTO `sys_user` VALUES (2, 'aj', 'fe805619645face2ccd68eb8140204530e306b3f4bb7a1adc089323f3ef887f4', '3re1dJKdSHdizGPT7xTM', '111111@qq.com', '1111111', 1, 7, '2018-03-13 16:17:25');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户与角色对应关系';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1, 2, 1);
INSERT INTO `sys_user_role` VALUES (2, 1, 2);
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `usertype` varchar(2) DEFAULT NULL COMMENT '用户类型',
  `enabled` int(2) DEFAULT NULL COMMENT '是否可用',
  `realname` varchar(32) DEFAULT NULL COMMENT '真实姓名',
  `qq` varchar(14) DEFAULT NULL COMMENT 'QQ',
  `email` varchar(100) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL COMMENT '联系电话',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户信息表';

SET FOREIGN_KEY_CHECKS = 1;
